Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 45005 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 7.2 MiB |
| Average record size in memory | 168.0 B |
Variable types
| Categorical | 6 |
|---|---|
| Numeric | 14 |
| DateTime | 1 |
Plate has a high cardinality: 1729 distinct values | High cardinality |
Deviation is highly correlated with Average_Deviation_Station_W5 and 3 other fields | High correlation |
Average_Deviation_Vehicle_W5 is highly correlated with Average_Deviation_Station_W5 and 4 other fields | High correlation |
Average_Deviation_Station_W5 is highly correlated with Deviation and 5 other fields | High correlation |
Average_Vehicle_Weekly is highly correlated with Average_Deviation_Vehicle_W5 and 3 other fields | High correlation |
Average_Station_Weekly is highly correlated with Deviation and 5 other fields | High correlation |
Average_Vehicle_Hourly is highly correlated with Deviation and 5 other fields | High correlation |
Average_Station_Hourly is highly correlated with Deviation and 4 other fields | High correlation |
Deviation is highly correlated with Average_Deviation_Station_W5 and 3 other fields | High correlation |
Average_Deviation_Vehicle_W5 is highly correlated with Average_Deviation_Station_W5 and 4 other fields | High correlation |
Average_Deviation_Station_W5 is highly correlated with Deviation and 5 other fields | High correlation |
Average_Vehicle_Weekly is highly correlated with Average_Deviation_Vehicle_W5 and 3 other fields | High correlation |
Average_Station_Weekly is highly correlated with Deviation and 5 other fields | High correlation |
Average_Vehicle_Hourly is highly correlated with Deviation and 5 other fields | High correlation |
Average_Station_Hourly is highly correlated with Deviation and 4 other fields | High correlation |
Deviation is highly correlated with Average_Vehicle_Hourly and 1 other fields | High correlation |
Average_Deviation_Station_W5 is highly correlated with Average_Station_Weekly | High correlation |
Average_Vehicle_Weekly is highly correlated with Average_Station_Weekly | High correlation |
Average_Station_Weekly is highly correlated with Average_Deviation_Station_W5 and 1 other fields | High correlation |
Average_Vehicle_Hourly is highly correlated with Deviation and 1 other fields | High correlation |
Average_Station_Hourly is highly correlated with Deviation and 1 other fields | High correlation |
Station is highly correlated with Vehicle_Type | High correlation |
Vehicle_Type is highly correlated with Station and 1 other fields | High correlation |
Product is highly correlated with Vehicle_Type | High correlation |
Vehicle_Type is highly correlated with Product and 1 other fields | High correlation |
CodProduct is highly correlated with Product and 1 other fields | High correlation |
Product is highly correlated with Vehicle_Type and 3 other fields | High correlation |
Tare is highly correlated with Qty_Ordered | High correlation |
Qty_Ordered is highly correlated with CodProduct and 2 other fields | High correlation |
Deviation is highly correlated with Block and 6 other fields | High correlation |
Station is highly correlated with Vehicle_Type and 1 other fields | High correlation |
Hour is highly correlated with Inspection | High correlation |
Month is highly correlated with Average_Vehicle_Weekly and 1 other fields | High correlation |
Inspection is highly correlated with Hour | High correlation |
Block is highly correlated with Deviation and 2 other fields | High correlation |
Average_Deviation_Vehicle_W5 is highly correlated with Deviation and 5 other fields | High correlation |
Average_Deviation_Station_W5 is highly correlated with Deviation and 5 other fields | High correlation |
Average_Vehicle_Weekly is highly correlated with Deviation and 6 other fields | High correlation |
Average_Station_Weekly is highly correlated with Deviation and 6 other fields | High correlation |
Average_Vehicle_Hourly is highly correlated with Deviation and 6 other fields | High correlation |
Average_Station_Hourly is highly correlated with Deviation and 6 other fields | High correlation |
Tare_Date has unique values | Unique |
Deviation has 760 (1.7%) zeros | Zeros |
Hour has 575 (1.3%) zeros | Zeros |
Percentage_Blocks has 31626 (70.3%) zeros | Zeros |
Reproduction
| Analysis started | 2022-05-26 16:13:52.710300 |
|---|---|
| Analysis finished | 2022-05-26 16:14:40.603646 |
| Duration | 47.89 seconds |
| Software version | pandas-profiling v3.2.0 |
| Download configuration | config.json |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 351.7 KiB |
| Z002 | |
|---|---|
| Z004 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 180020 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Z004 |
|---|---|
| 2nd row | Z004 |
| 3rd row | Z004 |
| 4th row | Z004 |
| 5th row | Z004 |
Common Values
| Value | Count | Frequency (%) |
| Z002 | 28038 | |
| Z004 | 16967 |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| z002 | 28038 | |
| z004 | 16967 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 90010 | |
| Z | 45005 | |
| 2 | 28038 | 15.6% |
| 4 | 16967 | 9.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 135015 | |
| Uppercase Letter | 45005 | 25.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 90010 | |
| 2 | 28038 | 20.8% |
| 4 | 16967 | 12.6% |
Uppercase Letter
| Value | Count | Frequency (%) |
| Z | 45005 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 135015 | |
| Latin | 45005 | 25.0% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 90010 | |
| 2 | 28038 | 20.8% |
| 4 | 16967 | 12.6% |
Latin
| Value | Count | Frequency (%) |
| Z | 45005 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 180020 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 90010 | |
| Z | 45005 | |
| 2 | 28038 | 15.6% |
| 4 | 16967 | 9.4% |
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.437773581 |
| Minimum | 2 |
|---|---|
| Maximum | 42 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 351.7 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 2 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 37 |
| Maximum | 42 |
| Range | 40 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 8.235186987 |
|---|---|
| Coefficient of variation (CV) | 1.51444095 |
| Kurtosis | 13.82027043 |
| Mean | 5.437773581 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 3.899142434 |
| Sum | 244727 |
| Variance | 67.8183047 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=9)
| Value | Count | Frequency (%) |
| 3 | 14444 | |
| 5 | 14215 | |
| 2 | 12254 | |
| 42 | 1127 | 2.5% |
| 6 | 967 | 2.1% |
| 40 | 728 | 1.6% |
| 11 | 449 | 1.0% |
| 37 | 429 | 1.0% |
| 7 | 392 | 0.9% |
| Value | Count | Frequency (%) |
| 2 | 12254 | |
| 3 | 14444 | |
| 5 | 14215 | |
| 6 | 967 | 2.1% |
| 7 | 392 | 0.9% |
| 11 | 449 | 1.0% |
| 37 | 429 | 1.0% |
| 40 | 728 | 1.6% |
| 42 | 1127 | 2.5% |
| Value | Count | Frequency (%) |
| 42 | 1127 | 2.5% |
| 40 | 728 | 1.6% |
| 37 | 429 | 1.0% |
| 11 | 449 | 1.0% |
| 7 | 392 | 0.9% |
| 6 | 967 | 2.1% |
| 5 | 14215 | |
| 3 | 14444 | |
| 2 | 12254 |
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 351.7 KiB |
| CIMENT II/AL 32,5 R PALETTE | |
|---|---|
| CIMENT I 42,5 R SAC | |
| CIMENT II/AL 32,5 R SAC | |
| CIMENT I 42,5 R SR3 PALETTE | 1127 |
| CIMENT I 42,5 R PALETTE | 967 |
| Other values (4) |
Length
| Max length | 28 |
|---|---|
| Median length | 27 |
| Mean length | 23.08405733 |
| Min length | 17 |
Characters and Unicode
| Total characters | 1038898 |
|---|---|
| Distinct characters | 23 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CIMENT II/AL 32,5 R PALETTE |
|---|---|
| 2nd row | CIMENT II/AL 32,5 R PALETTE |
| 3rd row | CIMENT II/AL 32,5 R PALETTE |
| 4th row | CIMENT II/AL 32,5 R PALETTE |
| 5th row | CIMENT II/AL 32,5 R PALETTE |
Common Values
| Value | Count | Frequency (%) |
| CIMENT II/AL 32,5 R PALETTE | 14444 | |
| CIMENT I 42,5 R SAC | 14215 | |
| CIMENT II/AL 32,5 R SAC | 12254 | |
| CIMENT I 42,5 R SR3 PALETTE | 1127 | 2.5% |
| CIMENT I 42,5 R PALETTE | 967 | 2.1% |
| CIMENT II/AL 42,5 N SAC | 728 | 1.6% |
| CHAUX CHA 10 SAC | 449 | 1.0% |
| CHAUX CHA 10 PALETTE | 429 | 1.0% |
| CIMENT I 42,5 R SR3 SAC | 392 | 0.9% |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| ciment | 44127 | |
| r | 43399 | |
| sac | 28038 | |
| ii/al | 27426 | |
| 32,5 | 26698 | |
| 42,5 | 17429 | 7.7% |
| palette | 16967 | 7.5% |
| i | 16701 | 7.4% |
| sr3 | 1519 | 0.7% |
| chaux | 878 | 0.4% |
| Other values (3) | 2484 | 1.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 183450 | ||
| I | 115680 | |
| E | 78061 | 7.5% |
| T | 78061 | 7.5% |
| A | 74187 | 7.1% |
| C | 73921 | 7.1% |
| R | 44918 | 4.3% |
| N | 44855 | 4.3% |
| L | 44393 | 4.3% |
| 5 | 44127 | 4.2% |
| Other values (13) | 257245 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 648239 | |
| Space Separator | 183450 | 17.7% |
| Decimal Number | 135656 | 13.1% |
| Other Punctuation | 71553 | 6.9% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 115680 | |
| E | 78061 | |
| T | 78061 | |
| A | 74187 | |
| C | 73921 | |
| R | 44918 | 6.9% |
| N | 44855 | 6.9% |
| L | 44393 | 6.8% |
| M | 44127 | 6.8% |
| S | 29557 | 4.6% |
| Other values (4) | 20479 | 3.2% |
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 44127 | |
| 2 | 44127 | |
| 3 | 28217 | |
| 4 | 17429 | 12.8% |
| 1 | 878 | 0.6% |
| 0 | 878 | 0.6% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 44127 | |
| / | 27426 |
Space Separator
| Value | Count | Frequency (%) |
| 183450 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 648239 | |
| Common | 390659 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| I | 115680 | |
| E | 78061 | |
| T | 78061 | |
| A | 74187 | |
| C | 73921 | |
| R | 44918 | 6.9% |
| N | 44855 | 6.9% |
| L | 44393 | 6.8% |
| M | 44127 | 6.8% |
| S | 29557 | 4.6% |
| Other values (4) | 20479 | 3.2% |
Common
| Value | Count | Frequency (%) |
| 183450 | ||
| 5 | 44127 | 11.3% |
| , | 44127 | 11.3% |
| 2 | 44127 | 11.3% |
| 3 | 28217 | 7.2% |
| / | 27426 | 7.0% |
| 4 | 17429 | 4.5% |
| 1 | 878 | 0.2% |
| 0 | 878 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1038898 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 183450 | ||
| I | 115680 | |
| E | 78061 | 7.5% |
| T | 78061 | 7.5% |
| A | 74187 | 7.1% |
| C | 73921 | 7.1% |
| R | 44918 | 4.3% |
| N | 44855 | 4.3% |
| L | 44393 | 4.3% |
| 5 | 44127 | 4.2% |
| Other values (13) | 257245 |
| Distinct | 1509 |
|---|---|
| Distinct (%) | 3.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15574.57749 |
| Minimum | 1560 |
|---|---|
| Maximum | 50580 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 351.7 KiB |
Quantile statistics
| Minimum | 1560 |
|---|---|
| 5-th percentile | 8540 |
| Q1 | 14620 |
| median | 15140 |
| Q3 | 15880 |
| 95-th percentile | 19574 |
| Maximum | 50580 |
| Range | 49020 |
| Interquartile range (IQR) | 1260 |
Descriptive statistics
| Standard deviation | 4056.332084 |
|---|---|
| Coefficient of variation (CV) | 0.2604457223 |
| Kurtosis | 12.58287861 |
| Mean | 15574.57749 |
| Median Absolute Deviation (MAD) | 620 |
| Skewness | 2.290968597 |
| Sum | 700933860 |
| Variance | 16453829.97 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 15100 | 553 | 1.2% |
| 14900 | 527 | 1.2% |
| 14800 | 510 | 1.1% |
| 15000 | 499 | 1.1% |
| 15200 | 495 | 1.1% |
| 15300 | 489 | 1.1% |
| 14960 | 461 | 1.0% |
| 14980 | 459 | 1.0% |
| 15240 | 442 | 1.0% |
| 15060 | 439 | 1.0% |
| Other values (1499) | 40131 |
| Value | Count | Frequency (%) |
| 1560 | 1 | < 0.1% |
| 1760 | 2 | < 0.1% |
| 1780 | 1 | < 0.1% |
| 1800 | 1 | < 0.1% |
| 1860 | 1 | < 0.1% |
| 1880 | 1 | < 0.1% |
| 2480 | 2 | < 0.1% |
| 2500 | 9 | < 0.1% |
| 2520 | 23 | |
| 2540 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 50580 | 1 | |
| 49380 | 1 | |
| 48380 | 1 | |
| 47780 | 1 | |
| 47440 | 1 | |
| 47380 | 1 | |
| 47100 | 1 | |
| 47020 | 1 | |
| 46940 | 1 | |
| 46800 | 1 |
| Distinct | 116 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28633.03411 |
| Minimum | 500 |
|---|---|
| Maximum | 105000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 351.7 KiB |
Quantile statistics
| Minimum | 500 |
|---|---|
| 5-th percentile | 13000 |
| Q1 | 30000 |
| median | 30000 |
| Q3 | 30000 |
| 95-th percentile | 35000 |
| Maximum | 105000 |
| Range | 104500 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 8425.838137 |
|---|---|
| Coefficient of variation (CV) | 0.294269832 |
| Kurtosis | 19.26417593 |
| Mean | 28633.03411 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.043382457 |
| Sum | 1288629700 |
| Variance | 70994748.32 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 30000 | 33285 | |
| 15000 | 2752 | 6.1% |
| 35000 | 2661 | 5.9% |
| 10000 | 741 | 1.6% |
| 25000 | 725 | 1.6% |
| 12000 | 438 | 1.0% |
| 20000 | 421 | 0.9% |
| 25500 | 288 | 0.6% |
| 5000 | 288 | 0.6% |
| 9000 | 273 | 0.6% |
| Other values (106) | 3133 | 7.0% |
| Value | Count | Frequency (%) |
| 500 | 1 | < 0.1% |
| 1000 | 10 | < 0.1% |
| 1500 | 7 | < 0.1% |
| 2000 | 16 | < 0.1% |
| 2500 | 8 | < 0.1% |
| 2800 | 3 | < 0.1% |
| 3000 | 69 | |
| 3500 | 5 | < 0.1% |
| 4000 | 38 | |
| 4500 | 7 | < 0.1% |
| Value | Count | Frequency (%) |
| 105000 | 1 | < 0.1% |
| 100000 | 38 | 0.1% |
| 95000 | 3 | < 0.1% |
| 90000 | 82 | |
| 88000 | 2 | < 0.1% |
| 87000 | 2 | < 0.1% |
| 86000 | 4 | < 0.1% |
| 85000 | 106 | |
| 84000 | 9 | < 0.1% |
| 83000 | 7 | < 0.1% |
| Distinct | 1431 |
|---|---|
| Distinct (%) | 3.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.6427949477 |
| Minimum | -3.08 |
|---|---|
| Maximum | 2.904761905 |
| Zeros | 760 |
| Zeros (%) | 1.7% |
| Negative | 9685 |
| Negative (%) | 21.5% |
| Memory size | 351.7 KiB |
Quantile statistics
| Minimum | -3.08 |
|---|---|
| 5-th percentile | -1.133333333 |
| Q1 | 0.1 |
| median | 0.7 |
| Q3 | 1.285714286 |
| 95-th percentile | 2.222222222 |
| Maximum | 2.904761905 |
| Range | 5.984761905 |
| Interquartile range (IQR) | 1.185714286 |
Descriptive statistics
| Standard deviation | 0.9894550089 |
|---|---|
| Coefficient of variation (CV) | 1.539301161 |
| Kurtosis | 0.5441664618 |
| Mean | 0.6427949477 |
| Median Absolute Deviation (MAD) | 0.6 |
| Skewness | -0.4536032009 |
| Sum | 28928.98662 |
| Variance | 0.9790212146 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 860 | 1.9% |
| 0.3333333333 | 858 | 1.9% |
| 0.6666666667 | 834 | 1.9% |
| 0.5 | 807 | 1.8% |
| 0 | 760 | 1.7% |
| 0.8333333333 | 697 | 1.5% |
| 0.6 | 675 | 1.5% |
| 0.8 | 662 | 1.5% |
| 0.4 | 651 | 1.4% |
| 0.1666666667 | 645 | 1.4% |
| Other values (1421) | 37556 |
| Value | Count | Frequency (%) |
| -3.08 | 1 | < 0.1% |
| -3.071428571 | 1 | < 0.1% |
| -3.066666667 | 8 | < 0.1% |
| -3.055555556 | 1 | < 0.1% |
| -3.035714286 | 1 | < 0.1% |
| -3.033333333 | 5 | < 0.1% |
| -3 | 28 | |
| -2.966666667 | 4 | < 0.1% |
| -2.96 | 1 | < 0.1% |
| -2.959183673 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2.904761905 | 1 | < 0.1% |
| 2.903225806 | 1 | < 0.1% |
| 2.901960784 | 1 | < 0.1% |
| 2.9 | 41 | |
| 2.896551724 | 1 | < 0.1% |
| 2.888888889 | 6 | < 0.1% |
| 2.885714286 | 3 | < 0.1% |
| 2.88 | 1 | < 0.1% |
| 2.875 | 3 | < 0.1% |
| 2.866666667 | 50 |
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 351.7 KiB |
| Unknown | |
|---|---|
| SPEED2 | |
| SPEED1 | |
| PAL | |
| AUTOPAC | |
| Other values (3) |
Length
| Max length | 7 |
|---|---|
| Median length | 6 |
| Mean length | 5.806665926 |
| Min length | 3 |
Characters and Unicode
| Total characters | 261329 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Unknown |
|---|---|
| 2nd row | Unknown |
| 3rd row | Unknown |
| 4th row | Unknown |
| 5th row | Unknown |
Common Values
| Value | Count | Frequency (%) |
| Unknown | 16260 | |
| SPEED2 | 5848 | 13.0% |
| SPEED1 | 5424 | 12.1% |
| PAL | 5009 | 11.1% |
| AUTOPAC | 4998 | 11.1% |
| PAL2 | 4048 | 9.0% |
| ENV2 | 1768 | 3.9% |
| ENV3 | 1650 | 3.7% |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| unknown | 16260 | |
| speed2 | 5848 | 13.0% |
| speed1 | 5424 | 12.1% |
| pal | 5009 | 11.1% |
| autopac | 4998 | 11.1% |
| pal2 | 4048 | 9.0% |
| env2 | 1768 | 3.9% |
| env3 | 1650 | 3.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 48780 | |
| E | 25962 | |
| P | 25327 | |
| U | 21258 | |
| A | 19053 | 7.3% |
| k | 16260 | 6.2% |
| o | 16260 | 6.2% |
| w | 16260 | 6.2% |
| 2 | 11664 | 4.5% |
| D | 11272 | 4.3% |
| Other values (9) | 49233 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 145031 | |
| Lowercase Letter | 97560 | |
| Decimal Number | 18738 | 7.2% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 25962 | |
| P | 25327 | |
| U | 21258 | |
| A | 19053 | |
| D | 11272 | |
| S | 11272 | |
| L | 9057 | 6.2% |
| T | 4998 | 3.4% |
| O | 4998 | 3.4% |
| C | 4998 | 3.4% |
| Other values (2) | 6836 | 4.7% |
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 48780 | |
| k | 16260 | 16.7% |
| o | 16260 | 16.7% |
| w | 16260 | 16.7% |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 11664 | |
| 1 | 5424 | |
| 3 | 1650 | 8.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 242591 | |
| Common | 18738 | 7.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 48780 | |
| E | 25962 | |
| P | 25327 | |
| U | 21258 | |
| A | 19053 | 7.9% |
| k | 16260 | 6.7% |
| o | 16260 | 6.7% |
| w | 16260 | 6.7% |
| D | 11272 | 4.6% |
| S | 11272 | 4.6% |
| Other values (6) | 30887 |
Common
| Value | Count | Frequency (%) |
| 2 | 11664 | |
| 1 | 5424 | |
| 3 | 1650 | 8.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 261329 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 48780 | |
| E | 25962 | |
| P | 25327 | |
| U | 21258 | |
| A | 19053 | 7.3% |
| k | 16260 | 6.2% |
| o | 16260 | 6.2% |
| w | 16260 | 6.2% |
| 2 | 11664 | 4.5% |
| D | 11272 | 4.3% |
| Other values (9) | 49233 |
| Distinct | 45005 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 351.7 KiB |
| Minimum | 2019-11-29 17:15:47.093000 |
|---|---|
| Maximum | 2022-05-05 11:20:57.730000 |
Histogram with fixed size bins (bins=50)
| Distinct | 1729 |
|---|---|
| Distinct (%) | 3.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 351.7 KiB |
| 117TU139 | 632 |
|---|---|
| 8277TU188 | 589 |
| 687TU166 | 566 |
| 6165TU183 | 489 |
| 6289TU143 | 463 |
| Other values (1724) |
Length
| Max length | 10 |
|---|---|
| Median length | 9 |
| Mean length | 8.719031219 |
| Min length | 3 |
Characters and Unicode
| Total characters | 392400 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 603 ? |
|---|---|
| Unique (%) | 1.3% |
Sample
| 1st row | 7952TU75 |
|---|---|
| 2nd row | 4350TU79 |
| 3rd row | 9836TU122 |
| 4th row | 6322TU130 |
| 5th row | 6505TU97 |
Common Values
| Value | Count | Frequency (%) |
| 117TU139 | 632 | 1.4% |
| 8277TU188 | 589 | 1.3% |
| 687TU166 | 566 | 1.3% |
| 6165TU183 | 489 | 1.1% |
| 6289TU143 | 463 | 1.0% |
| 9788TU123 | 443 | 1.0% |
| 3133TU173 | 437 | 1.0% |
| 4857TU106 | 422 | 0.9% |
| 5567TU92 | 409 | 0.9% |
| 3904TU216 | 409 | 0.9% |
| Other values (1719) | 40146 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 117tu139 | 633 | 1.4% |
| 8277tu188 | 589 | 1.3% |
| 687tu166 | 566 | 1.3% |
| 6165tu183 | 489 | 1.1% |
| 6289tu143 | 463 | 1.0% |
| 9788tu123 | 443 | 1.0% |
| 3133tu173 | 437 | 1.0% |
| 4857tu106 | 422 | 0.9% |
| 5567tu92 | 409 | 0.9% |
| 3904tu216 | 409 | 0.9% |
| Other values (1714) | 40145 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 56414 | |
| T | 44219 | |
| U | 44219 | |
| 2 | 33024 | |
| 8 | 29823 | |
| 7 | 28578 | |
| 3 | 28174 | |
| 9 | 27798 | |
| 6 | 26456 | |
| 5 | 25239 | |
| Other values (6) | 48456 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 303902 | |
| Uppercase Letter | 88488 | 22.6% |
| Lowercase Letter | 10 | < 0.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 56414 | |
| 2 | 33024 | |
| 8 | 29823 | |
| 7 | 28578 | |
| 3 | 28174 | |
| 9 | 27798 | |
| 6 | 26456 | |
| 5 | 25239 | |
| 0 | 24217 | |
| 4 | 24179 |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 44219 | |
| U | 44219 | |
| R | 25 | < 0.1% |
| S | 25 | < 0.1% |
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 5 | |
| u | 5 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 303902 | |
| Latin | 88498 | 22.6% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 56414 | |
| 2 | 33024 | |
| 8 | 29823 | |
| 7 | 28578 | |
| 3 | 28174 | |
| 9 | 27798 | |
| 6 | 26456 | |
| 5 | 25239 | |
| 0 | 24217 | |
| 4 | 24179 |
Latin
| Value | Count | Frequency (%) |
| T | 44219 | |
| U | 44219 | |
| R | 25 | < 0.1% |
| S | 25 | < 0.1% |
| t | 5 | < 0.1% |
| u | 5 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 392400 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 56414 | |
| T | 44219 | |
| U | 44219 | |
| 2 | 33024 | |
| 8 | 29823 | |
| 7 | 28578 | |
| 3 | 28174 | |
| 9 | 27798 | |
| 6 | 26456 | |
| 5 | 25239 | |
| Other values (6) | 48456 |
| Distinct | 24 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.87639151 |
| Minimum | 0 |
|---|---|
| Maximum | 23 |
| Zeros | 575 |
| Zeros (%) | 1.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 351.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 8 |
| median | 11 |
| Q3 | 16 |
| 95-th percentile | 21 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 5.245169881 |
|---|---|
| Coefficient of variation (CV) | 0.4416467642 |
| Kurtosis | -0.6176640195 |
| Mean | 11.87639151 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 0.1246842755 |
| Sum | 534497 |
| Variance | 27.51180708 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=24)
| Value | Count | Frequency (%) |
| 11 | 3449 | 7.7% |
| 10 | 3220 | 7.2% |
| 9 | 3008 | 6.7% |
| 14 | 2976 | 6.6% |
| 6 | 2969 | 6.6% |
| 15 | 2757 | 6.1% |
| 8 | 2747 | 6.1% |
| 5 | 2619 | 5.8% |
| 7 | 2532 | 5.6% |
| 13 | 2452 | 5.4% |
| Other values (14) | 16276 |
| Value | Count | Frequency (%) |
| 0 | 575 | 1.3% |
| 1 | 406 | 0.9% |
| 2 | 325 | 0.7% |
| 3 | 463 | 1.0% |
| 4 | 403 | 0.9% |
| 5 | 2619 | |
| 6 | 2969 | |
| 7 | 2532 | |
| 8 | 2747 | |
| 9 | 3008 |
| Value | Count | Frequency (%) |
| 23 | 818 | 1.8% |
| 22 | 1052 | 2.3% |
| 21 | 1324 | |
| 20 | 863 | 1.9% |
| 19 | 1307 | |
| 18 | 1692 | |
| 17 | 2222 | |
| 16 | 2432 | |
| 15 | 2757 | |
| 14 | 2976 |
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.569758916 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 351.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 7 |
| Q3 | 10 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 3.603240235 |
|---|---|
| Coefficient of variation (CV) | 0.5484585174 |
| Kurtosis | -1.346857439 |
| Mean | 6.569758916 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.007973125996 |
| Sum | 295672 |
| Variance | 12.98334019 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 3 | 5623 | |
| 12 | 4729 | |
| 10 | 4028 | |
| 11 | 3941 | |
| 6 | 3834 | |
| 2 | 3774 | |
| 9 | 3701 | |
| 1 | 3635 | |
| 4 | 3190 | |
| 7 | 3104 | |
| Other values (2) | 5446 |
| Value | Count | Frequency (%) |
| 1 | 3635 | |
| 2 | 3774 | |
| 3 | 5623 | |
| 4 | 3190 | |
| 5 | 2376 | |
| 6 | 3834 | |
| 7 | 3104 | |
| 8 | 3070 | |
| 9 | 3701 | |
| 10 | 4028 |
| Value | Count | Frequency (%) |
| 12 | 4729 | |
| 11 | 3941 | |
| 10 | 4028 | |
| 9 | 3701 | |
| 8 | 3070 | |
| 7 | 3104 | |
| 6 | 3834 | |
| 5 | 2376 | |
| 4 | 3190 | |
| 3 | 5623 |
Day
Real number (ℝ≥0)
| Distinct | 31 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.76622597 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 351.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 24 |
| 95-th percentile | 30 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 8.921466114 |
|---|---|
| Coefficient of variation (CV) | 0.565859333 |
| Kurtosis | -1.243294191 |
| Mean | 15.76622597 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.0289489114 |
| Sum | 709559 |
| Variance | 79.59255763 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=31)
| Value | Count | Frequency (%) |
| 9 | 1682 | 3.7% |
| 29 | 1678 | 3.7% |
| 8 | 1673 | 3.7% |
| 2 | 1624 | 3.6% |
| 11 | 1624 | 3.6% |
| 3 | 1595 | 3.5% |
| 24 | 1591 | 3.5% |
| 28 | 1564 | 3.5% |
| 7 | 1558 | 3.5% |
| 25 | 1533 | 3.4% |
| Other values (21) | 28883 |
| Value | Count | Frequency (%) |
| 1 | 1228 | |
| 2 | 1624 | |
| 3 | 1595 | |
| 4 | 1510 | |
| 5 | 1432 | |
| 6 | 1466 | |
| 7 | 1558 | |
| 8 | 1673 | |
| 9 | 1682 | |
| 10 | 1526 |
| Value | Count | Frequency (%) |
| 31 | 866 | |
| 30 | 1495 | |
| 29 | 1678 | |
| 28 | 1564 | |
| 27 | 1342 | |
| 26 | 1499 | |
| 25 | 1533 | |
| 24 | 1591 | |
| 23 | 1502 | |
| 22 | 1336 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 351.7 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 45005 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 33158 | |
| 1 | 11847 | 26.3% |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 33158 | |
| 1 | 11847 | 26.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 33158 | |
| 1 | 11847 | 26.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 45005 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 33158 | |
| 1 | 11847 | 26.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 45005 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 33158 | |
| 1 | 11847 | 26.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 45005 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 33158 | |
| 1 | 11847 | 26.3% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 351.7 KiB |
| 0 | |
|---|---|
| 1 | 3938 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 45005 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 41067 | |
| 1 | 3938 | 8.8% |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0 | 41067 | |
| 1 | 3938 | 8.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 41067 | |
| 1 | 3938 | 8.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 45005 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 41067 | |
| 1 | 3938 | 8.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 45005 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 41067 | |
| 1 | 3938 | 8.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 45005 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 41067 | |
| 1 | 3938 | 8.8% |
| Distinct | 32344 |
|---|---|
| Distinct (%) | 71.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.6427321895 |
| Minimum | -2.273333333 |
|---|---|
| Maximum | 2.7875 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 7105 |
| Negative (%) | 15.8% |
| Memory size | 351.7 KiB |
Quantile statistics
| Minimum | -2.273333333 |
|---|---|
| 5-th percentile | -0.54 |
| Q1 | 0.2428571429 |
| median | 0.6761904762 |
| Q3 | 1.086666667 |
| 95-th percentile | 1.69047619 |
| Maximum | 2.7875 |
| Range | 5.060833333 |
| Interquartile range (IQR) | 0.8438095238 |
Descriptive statistics
| Standard deviation | 0.6680779873 |
|---|---|
| Coefficient of variation (CV) | 1.039434462 |
| Kurtosis | 0.3671083222 |
| Mean | 0.6427321895 |
| Median Absolute Deviation (MAD) | 0.4228571429 |
| Skewness | -0.3439902595 |
| Sum | 28926.16219 |
| Variance | 0.4463281972 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.5333333333 | 17 | < 0.1% |
| 1.066666667 | 15 | < 0.1% |
| 1.033333333 | 15 | < 0.1% |
| 0.7866666667 | 14 | < 0.1% |
| 0.5 | 13 | < 0.1% |
| 1.266666667 | 13 | < 0.1% |
| 0.5666666667 | 13 | < 0.1% |
| 1.033333333 | 13 | < 0.1% |
| 1.213333333 | 12 | < 0.1% |
| 1.013333333 | 12 | < 0.1% |
| Other values (32334) | 44868 |
| Value | Count | Frequency (%) |
| -2.273333333 | 1 | |
| -2.259047619 | 1 | |
| -2.252380952 | 1 | |
| -2.21 | 1 | |
| -2.159047619 | 1 | |
| -2.118666667 | 1 | |
| -2.113333333 | 1 | |
| -2.053333333 | 1 | |
| -2 | 1 | |
| -1.986666667 | 1 |
| Value | Count | Frequency (%) |
| 2.7875 | 1 | |
| 2.673333333 | 1 | |
| 2.64 | 1 | |
| 2.619047619 | 1 | |
| 2.617142857 | 1 | |
| 2.614285714 | 1 | |
| 2.608333333 | 1 | |
| 2.6 | 1 | |
| 2.6 | 1 | |
| 2.59858679 | 1 |
Average_Deviation_Station_W5
Real number (ℝ)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 29615 |
|---|---|
| Distinct (%) | 65.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.6426083142 |
| Minimum | -2.71037037 |
|---|---|
| Maximum | 2.7875 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 7294 |
| Negative (%) | 16.2% |
| Memory size | 351.7 KiB |
Quantile statistics
| Minimum | -2.71037037 |
|---|---|
| 5-th percentile | -0.7 |
| Q1 | 0.2533333333 |
| median | 0.6933333333 |
| Q3 | 1.113333333 |
| 95-th percentile | 1.76 |
| Maximum | 2.7875 |
| Range | 5.49787037 |
| Interquartile range (IQR) | 0.86 |
Descriptive statistics
| Standard deviation | 0.7293835214 |
|---|---|
| Coefficient of variation (CV) | 1.135035924 |
| Kurtosis | 0.9552737495 |
| Mean | 0.6426083142 |
| Median Absolute Deviation (MAD) | 0.4298305085 |
| Skewness | -0.5722648232 |
| Sum | 28920.58718 |
| Variance | 0.5320003213 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.4 | 19 | < 0.1% |
| 0.8533333333 | 19 | < 0.1% |
| 1 | 19 | < 0.1% |
| 0.7066666667 | 18 | < 0.1% |
| 0.3666666667 | 18 | < 0.1% |
| 0.8333333333 | 18 | < 0.1% |
| 1.093333333 | 18 | < 0.1% |
| 0.5733333333 | 18 | < 0.1% |
| 1.06 | 17 | < 0.1% |
| 0.68 | 17 | < 0.1% |
| Other values (29605) | 44824 |
| Value | Count | Frequency (%) |
| -2.71037037 | 1 | |
| -2.62 | 1 | |
| -2.613333333 | 1 | |
| -2.606666667 | 1 | |
| -2.603703704 | 1 | |
| -2.575913978 | 1 | |
| -2.559058824 | 1 | |
| -2.549583333 | 1 | |
| -2.549247312 | 1 | |
| -2.542580645 | 1 |
| Value | Count | Frequency (%) |
| 2.7875 | 1 | |
| 2.786111111 | 1 | |
| 2.77457265 | 1 | |
| 2.753333333 | 1 | |
| 2.711111111 | 1 | |
| 2.701495726 | 1 | |
| 2.690384615 | 1 | |
| 2.688888889 | 1 | |
| 2.666666667 | 1 | |
| 2.653333333 | 1 |
Average_Vehicle_Weekly
Real number (ℝ)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 246 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.6428158874 |
| Minimum | -0.5533123918 |
|---|---|
| Maximum | 1.782937883 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 3537 |
| Negative (%) | 7.9% |
| Memory size | 351.7 KiB |
Quantile statistics
| Minimum | -0.5533123918 |
|---|---|
| 5-th percentile | -0.2854489728 |
| Q1 | 0.3804835896 |
| median | 0.65737362 |
| Q3 | 0.9401111367 |
| 95-th percentile | 1.439045263 |
| Maximum | 1.782937883 |
| Range | 2.336250275 |
| Interquartile range (IQR) | 0.5596275472 |
Descriptive statistics
| Standard deviation | 0.4429963055 |
|---|---|
| Coefficient of variation (CV) | 0.6891495904 |
| Kurtosis | 0.5581371008 |
| Mean | 0.6428158874 |
| Median Absolute Deviation (MAD) | 0.2768900304 |
| Skewness | -0.292749531 |
| Sum | 28929.92901 |
| Variance | 0.1962457267 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.2563274769 | 468 | 1.0% |
| 0.360029522 | 456 | 1.0% |
| 0.4009192954 | 443 | 1.0% |
| 0.9401111367 | 438 | 1.0% |
| 0.915772554 | 421 | 0.9% |
| 0.4231653858 | 389 | 0.9% |
| 0.7915963831 | 388 | 0.9% |
| -0.3740278066 | 354 | 0.8% |
| 0.1641094091 | 344 | 0.8% |
| 0.83060979 | 340 | 0.8% |
| Other values (236) | 40964 |
| Value | Count | Frequency (%) |
| -0.5533123918 | 314 | |
| -0.5308365733 | 289 | |
| -0.5030525334 | 208 | |
| -0.4323881149 | 329 | |
| -0.42423959 | 117 | 0.3% |
| -0.4135966172 | 284 | |
| -0.3740278066 | 354 | |
| -0.3186466638 | 320 | |
| -0.2854489728 | 219 | |
| -0.1306056381 | 139 | 0.3% |
| Value | Count | Frequency (%) |
| 1.782937883 | 186 | |
| 1.744887348 | 141 | |
| 1.727435991 | 111 | |
| 1.677697487 | 182 | |
| 1.676344086 | 31 | 0.1% |
| 1.636812173 | 152 | |
| 1.628279736 | 72 | 0.2% |
| 1.568198273 | 190 | |
| 1.560102554 | 110 | |
| 1.522991434 | 189 |
Average_Station_Weekly
Real number (ℝ)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 797 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.6428258089 |
| Minimum | -1.7 |
|---|---|
| Maximum | 2.522222222 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Negative | 5051 |
| Negative (%) | 11.2% |
| Memory size | 351.7 KiB |
Quantile statistics
| Minimum | -1.7 |
|---|---|
| 5-th percentile | -0.4322791344 |
| Q1 | 0.3969914935 |
| median | 0.6867207601 |
| Q3 | 0.9607057669 |
| 95-th percentile | 1.432153966 |
| Maximum | 2.522222222 |
| Range | 4.222222222 |
| Interquartile range (IQR) | 0.5637142734 |
Descriptive statistics
| Standard deviation | 0.5496491156 |
|---|---|
| Coefficient of variation (CV) | 0.8550514119 |
| Kurtosis | 1.709212842 |
| Mean | 0.6428258089 |
| Median Absolute Deviation (MAD) | 0.2763354377 |
| Skewness | -0.7113110133 |
| Sum | 28930.37553 |
| Variance | 0.3021141502 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.8321674964 | 563 | 1.3% |
| 0.8920709736 | 466 | 1.0% |
| 1.027712345 | 466 | 1.0% |
| 1.014274016 | 407 | 0.9% |
| 1.143236913 | 405 | 0.9% |
| 0.7747221488 | 394 | 0.9% |
| 0.8155479372 | 370 | 0.8% |
| 0.9373412701 | 360 | 0.8% |
| 0.3843046246 | 358 | 0.8% |
| 0.5225990787 | 355 | 0.8% |
| Other values (787) | 40861 |
| Value | Count | Frequency (%) |
| -1.7 | 1 | < 0.1% |
| -1.664131513 | 100 | |
| -1.588888889 | 3 | < 0.1% |
| -1.533333333 | 1 | < 0.1% |
| -1.496143251 | 11 | < 0.1% |
| -1.392857143 | 3 | < 0.1% |
| -1.315880093 | 117 | |
| -1.288888889 | 3 | < 0.1% |
| -1.251323476 | 73 | |
| -1.095364441 | 87 |
| Value | Count | Frequency (%) |
| 2.522222222 | 3 | < 0.1% |
| 2.333333333 | 1 | < 0.1% |
| 2.266666667 | 1 | < 0.1% |
| 2.239583333 | 32 | |
| 2.185714286 | 6 | < 0.1% |
| 2.169575385 | 41 | |
| 2.133333333 | 2 | < 0.1% |
| 2.111764706 | 17 | |
| 2.047698413 | 15 | < 0.1% |
| 2.023333333 | 10 | < 0.1% |
Average_Vehicle_Hourly
Real number (ℝ)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 7836 |
|---|---|
| Distinct (%) | 17.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.6427469723 |
| Minimum | -3.055555556 |
|---|---|
| Maximum | 2.9 |
| Zeros | 191 |
| Zeros (%) | 0.4% |
| Negative | 8053 |
| Negative (%) | 17.9% |
| Memory size | 351.7 KiB |
Quantile statistics
| Minimum | -3.055555556 |
|---|---|
| 5-th percentile | -0.6916666667 |
| Q1 | 0.2 |
| median | 0.6833333333 |
| Q3 | 1.14047619 |
| 95-th percentile | 1.85 |
| Maximum | 2.9 |
| Range | 5.955555556 |
| Interquartile range (IQR) | 0.9404761905 |
Descriptive statistics
| Standard deviation | 0.7733023656 |
|---|---|
| Coefficient of variation (CV) | 1.203120977 |
| Kurtosis | 0.8084644304 |
| Mean | 0.6427469723 |
| Median Absolute Deviation (MAD) | 0.4722222222 |
| Skewness | -0.380238754 |
| Sum | 28926.82749 |
| Variance | 0.5979965487 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.5 | 258 | 0.6% |
| 1 | 195 | 0.4% |
| 0 | 191 | 0.4% |
| 0.6 | 187 | 0.4% |
| 0.8 | 171 | 0.4% |
| 1.5 | 169 | 0.4% |
| 0.4 | 150 | 0.3% |
| 1.2 | 141 | 0.3% |
| 0.7 | 136 | 0.3% |
| 0.9 | 133 | 0.3% |
| Other values (7826) | 43274 |
| Value | Count | Frequency (%) |
| -3.055555556 | 1 | < 0.1% |
| -3.033333333 | 1 | < 0.1% |
| -3 | 7 | |
| -2.959183673 | 1 | < 0.1% |
| -2.933333333 | 2 | < 0.1% |
| -2.9 | 2 | < 0.1% |
| -2.866666667 | 2 | < 0.1% |
| -2.857142857 | 3 | |
| -2.833333333 | 1 | < 0.1% |
| -2.8 | 3 |
| Value | Count | Frequency (%) |
| 2.9 | 15 | |
| 2.885714286 | 1 | < 0.1% |
| 2.88 | 1 | < 0.1% |
| 2.86827957 | 2 | < 0.1% |
| 2.866666667 | 12 | |
| 2.861111111 | 1 | < 0.1% |
| 2.857142857 | 2 | < 0.1% |
| 2.833333333 | 10 | |
| 2.816666667 | 2 | < 0.1% |
| 2.8125 | 1 | < 0.1% |
Average_Station_Hourly
Real number (ℝ)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 6280 |
|---|---|
| Distinct (%) | 14.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.6427950923 |
| Minimum | -3.066666667 |
|---|---|
| Maximum | 2.9 |
| Zeros | 383 |
| Zeros (%) | 0.9% |
| Negative | 8438 |
| Negative (%) | 18.7% |
| Memory size | 351.7 KiB |
Quantile statistics
| Minimum | -3.066666667 |
|---|---|
| 5-th percentile | -0.9333333333 |
| Q1 | 0.1818181818 |
| median | 0.7 |
| Q3 | 1.197222222 |
| 95-th percentile | 2 |
| Maximum | 2.9 |
| Range | 5.966666667 |
| Interquartile range (IQR) | 1.01540404 |
Descriptive statistics
| Standard deviation | 0.8704824323 |
|---|---|
| Coefficient of variation (CV) | 1.354214497 |
| Kurtosis | 0.9290329978 |
| Mean | 0.6427950923 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | -0.5269685384 |
| Sum | 28928.99313 |
| Variance | 0.7577396649 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.5 | 411 | 0.9% |
| 0 | 383 | 0.9% |
| 0.6 | 343 | 0.8% |
| 1 | 329 | 0.7% |
| 0.3333333333 | 317 | 0.7% |
| 0.6666666667 | 303 | 0.7% |
| 0.8 | 287 | 0.6% |
| 1.2 | 272 | 0.6% |
| 0.4 | 268 | 0.6% |
| 0.8333333333 | 266 | 0.6% |
| Other values (6270) | 41826 |
| Value | Count | Frequency (%) |
| -3.066666667 | 3 | < 0.1% |
| -3.055555556 | 1 | < 0.1% |
| -3.033333333 | 3 | < 0.1% |
| -3 | 14 | |
| -2.966666667 | 3 | < 0.1% |
| -2.959183673 | 1 | < 0.1% |
| -2.933333333 | 2 | < 0.1% |
| -2.933333333 | 6 | |
| -2.901785714 | 1 | < 0.1% |
| -2.9 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 2.9 | 23 | |
| 2.888888889 | 2 | < 0.1% |
| 2.885714286 | 2 | < 0.1% |
| 2.88 | 1 | < 0.1% |
| 2.875 | 2 | < 0.1% |
| 2.86827957 | 2 | < 0.1% |
| 2.866666667 | 20 | |
| 2.861111111 | 1 | < 0.1% |
| 2.857142857 | 3 | < 0.1% |
| 2.84 | 1 | < 0.1% |
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.07729807799 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 31626 |
| Zeros (%) | 70.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 351.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.2 |
| 95-th percentile | 0.4 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.2 |
Descriptive statistics
| Standard deviation | 0.1343414601 |
|---|---|
| Coefficient of variation (CV) | 1.737966371 |
| Kurtosis | 3.663630504 |
| Mean | 0.07729807799 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.873662499 |
| Sum | 3478.8 |
| Variance | 0.01804762791 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 0 | 31626 | |
| 0.2 | 10075 | 22.4% |
| 0.4 | 2677 | 5.9% |
| 0.6 | 550 | 1.2% |
| 0.8 | 70 | 0.2% |
| 1 | 7 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 31626 | |
| 0.2 | 10075 | 22.4% |
| 0.4 | 2677 | 5.9% |
| 0.6 | 550 | 1.2% |
| 0.8 | 70 | 0.2% |
| 1 | 7 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 7 | < 0.1% |
| 0.8 | 70 | 0.2% |
| 0.6 | 550 | 1.2% |
| 0.4 | 2677 | 5.9% |
| 0.2 | 10075 | 22.4% |
| 0 | 31626 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| Vehicle_Type | CodProduct | Product | Tare | Qty_Ordered | Deviation | Station | Tare_Date | Plate | Hour | Month | Day | Inspection | Block | Average_Deviation_Vehicle_W5 | Average_Deviation_Station_W5 | Average_Vehicle_Weekly | Average_Station_Weekly | Average_Vehicle_Hourly | Average_Station_Hourly | Percentage_Blocks | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Z004 | 3 | CIMENT II/AL 32,5 R PALETTE | 14660 | 30000.0 | 0.200000 | Unknown | 2019-11-29 17:15:47.093 | 7952TU75 | 17 | 11 | 29 | 0 | 0 | 0.926667 | 1.043333 | 0.841599 | 0.893275 | 0.992000 | 1.021746 | 0.0 |
| 1 | Z004 | 3 | CIMENT II/AL 32,5 R PALETTE | 14740 | 25000.0 | 1.160000 | Unknown | 2019-11-29 17:18:52.210 | 4350TU79 | 17 | 11 | 29 | 0 | 0 | 0.733333 | 0.890000 | 0.841599 | 0.893275 | 0.992000 | 1.021746 | 0.0 |
| 2 | Z004 | 3 | CIMENT II/AL 32,5 R PALETTE | 15880 | 30000.0 | 1.433333 | Unknown | 2019-11-29 17:29:35.060 | 9836TU122 | 17 | 11 | 29 | 0 | 0 | 0.912000 | 0.868667 | 0.841599 | 0.893275 | 0.992000 | 1.021746 | 0.0 |
| 3 | Z004 | 3 | CIMENT II/AL 32,5 R PALETTE | 14620 | 30000.0 | 0.400000 | Unknown | 2019-11-29 17:33:10.127 | 6322TU130 | 17 | 11 | 29 | 0 | 0 | 1.005333 | 0.902000 | 0.841599 | 0.893275 | 0.992000 | 1.021746 | 0.0 |
| 4 | Z004 | 3 | CIMENT II/AL 32,5 R PALETTE | 15380 | 30000.0 | 1.766667 | Unknown | 2019-11-29 17:48:10.530 | 6505TU97 | 17 | 11 | 29 | 0 | 0 | 0.832000 | 0.925333 | 0.841599 | 0.893275 | 0.992000 | 1.021746 | 0.0 |
| 5 | Z002 | 5 | CIMENT I 42,5 R SAC | 16100 | 35000.0 | 1.285714 | Unknown | 2019-11-29 17:50:01.907 | 2156TU185 | 17 | 11 | 29 | 0 | 0 | 0.996667 | 1.238667 | 0.755664 | 0.893275 | 1.058929 | 1.021746 | 0.0 |
| 6 | Z002 | 5 | CIMENT I 42,5 R SAC | 15080 | 30000.0 | 0.766667 | Unknown | 2019-11-29 17:59:14.167 | 5809TU158 | 17 | 11 | 29 | 0 | 0 | 1.140476 | 1.263810 | 0.755664 | 0.893275 | 1.058929 | 1.021746 | 0.0 |
| 7 | Z002 | 5 | CIMENT I 42,5 R SAC | 14640 | 30000.0 | 1.300000 | Unknown | 2019-11-29 18:02:25.287 | 2189TU151 | 18 | 11 | 29 | 1 | 0 | 1.100476 | 1.130476 | 0.755664 | 0.893275 | 0.708333 | 0.886395 | 0.0 |
| 8 | Z004 | 3 | CIMENT II/AL 32,5 R PALETTE | 15120 | 30000.0 | 0.566667 | Unknown | 2019-11-29 18:06:43.730 | 2872TU107 | 18 | 11 | 29 | 1 | 0 | 0.992000 | 1.310476 | 0.841599 | 0.893275 | 1.123810 | 0.886395 | 0.0 |
| 9 | Z004 | 3 | CIMENT II/AL 32,5 R PALETTE | 15140 | 35000.0 | 0.971429 | Unknown | 2019-11-29 18:21:42.127 | 2552TU154 | 18 | 11 | 29 | 1 | 0 | 1.065333 | 1.137143 | 0.841599 | 0.893275 | 1.123810 | 0.886395 | 0.0 |
Last rows
| Vehicle_Type | CodProduct | Product | Tare | Qty_Ordered | Deviation | Station | Tare_Date | Plate | Hour | Month | Day | Inspection | Block | Average_Deviation_Vehicle_W5 | Average_Deviation_Station_W5 | Average_Vehicle_Weekly | Average_Station_Weekly | Average_Vehicle_Hourly | Average_Station_Hourly | Percentage_Blocks | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 44995 | Z002 | 2 | CIMENT II/AL 32,5 R SAC | 7250 | 10000.0 | 1.000000 | SPEED2 | 2022-05-05 08:07:32.693 | 1338TU219 | 8 | 5 | 5 | 0 | 0 | -0.185714 | 0.700000 | 0.077636 | 0.763889 | 0.023810 | 1.000000 | 0.2 |
| 44996 | Z002 | 2 | CIMENT II/AL 32,5 R SAC | 15000 | 30000.0 | 0.666667 | AUTOPAC | 2022-05-05 09:32:17.310 | 3513TU89 | 9 | 5 | 5 | 0 | 0 | -0.052381 | 0.266667 | 0.077636 | 0.366667 | 0.666667 | 0.583333 | 0.0 |
| 44997 | Z002 | 2 | CIMENT II/AL 32,5 R SAC | 15650 | 30000.0 | 0.500000 | AUTOPAC | 2022-05-05 09:36:21.127 | 8170TU152 | 9 | 5 | 5 | 0 | 0 | 0.180952 | 0.466667 | 0.077636 | 0.366667 | 0.666667 | 0.583333 | 0.0 |
| 44998 | Z004 | 3 | CIMENT II/AL 32,5 R PALETTE | 2950 | 5000.0 | 1.000000 | PAL2 | 2022-05-05 09:42:18.773 | 1718TU112 | 9 | 5 | 5 | 0 | 0 | 0.206667 | 0.206667 | 0.562599 | 0.464399 | 1.000000 | 1.000000 | 0.0 |
| 44999 | Z002 | 2 | CIMENT II/AL 32,5 R SAC | 15250 | 30000.0 | 0.833333 | SPEED2 | 2022-05-05 09:42:57.557 | 319TU113 | 9 | 5 | 5 | 0 | 0 | 0.247619 | 0.800000 | 0.077636 | 0.763889 | 0.666667 | 0.833333 | 0.0 |
| 45000 | Z004 | 42 | CIMENT I 42,5 R SR3 PALETTE | 7450 | 10000.0 | 1.500000 | PAL | 2022-05-05 10:04:47.597 | 7891TU183 | 10 | 5 | 5 | 0 | 0 | 0.873333 | 0.388889 | 0.562599 | 1.250000 | 1.500000 | 1.500000 | 0.0 |
| 45001 | Z002 | 5 | CIMENT I 42,5 R SAC | 14800 | 30000.0 | -0.166667 | SPEED1 | 2022-05-05 10:09:35.890 | 5944TU137 | 10 | 5 | 5 | 0 | 0 | 0.500000 | -0.528571 | 0.077636 | -0.578297 | -0.444444 | -0.444444 | 0.2 |
| 45002 | Z002 | 5 | CIMENT I 42,5 R SAC | 14800 | 30000.0 | -0.666667 | SPEED1 | 2022-05-05 10:29:36.163 | 834TU182 | 10 | 5 | 5 | 0 | 0 | 0.566667 | -0.461905 | 0.077636 | -0.578297 | -0.444444 | -0.444444 | 0.0 |
| 45003 | Z002 | 5 | CIMENT I 42,5 R SAC | 15600 | 30000.0 | -0.500000 | SPEED1 | 2022-05-05 10:53:35.463 | 7472TU203 | 10 | 5 | 5 | 0 | 0 | 0.233333 | -0.452381 | 0.077636 | -0.578297 | -0.444444 | -0.444444 | 0.2 |
| 45004 | Z004 | 3 | CIMENT II/AL 32,5 R PALETTE | 14250 | 15000.0 | 1.000000 | PAL | 2022-05-05 11:20:57.730 | 9400TU157 | 11 | 5 | 5 | 0 | 0 | 1.133333 | 0.755556 | 0.562599 | 1.250000 | 1.000000 | 1.000000 | 0.0 |